Dataset statistics
| Number of variables | 16 |
|---|---|
| Number of observations | 7295 |
| Missing cells | 766 |
| Missing cells (%) | 0.7% |
| Duplicate rows | 6144 |
| Duplicate rows (%) | 84.2% |
| Total size in memory | 833.8 KiB |
| Average record size in memory | 117.0 B |
Variable types
| Numeric | 10 |
|---|---|
| DateTime | 1 |
| Categorical | 5 |
| Dataset has 6144 (84.2%) duplicate rows | Duplicates |
Customer_name has a high cardinality: 214 distinct values | High cardinality |
Customer_address has a high cardinality: 131 distinct values | High cardinality |
No is highly overall correlated with Orignal_price | High correlation |
Item_code is highly overall correlated with Discount_price and 3 other fields | High correlation |
Orignal_price is highly overall correlated with No and 4 other fields | High correlation |
PCS is highly overall correlated with Discount_price | High correlation |
Total_discount is highly overall correlated with Orignal_price and 2 other fields | High correlation |
Discount_price is highly overall correlated with Item_code and 3 other fields | High correlation |
Discount_per_piece is highly overall correlated with Orignal_price and 4 other fields | High correlation |
Product_name is highly overall correlated with Item_code and 2 other fields | High correlation |
Price Range is highly overall correlated with Item_code and 4 other fields | High correlation |
Has_Discount is highly overall correlated with Item_code and 4 other fields | High correlation |
Price Range has 766 (10.5%) missing values | Missing |
PCS is highly skewed (γ1 = 28.05350099) | Skewed |
Total_discount is highly skewed (γ1 = 23.54544337) | Skewed |
CTN has 6983 (95.7%) zeros | Zeros |
Total_discount has 4855 (66.6%) zeros | Zeros |
Discount_per_piece has 4855 (66.6%) zeros | Zeros |
Reproduction
| Analysis started | 2023-05-12 07:11:24.441138 |
|---|---|
| Analysis finished | 2023-05-12 07:11:45.193856 |
| Duration | 20.75 seconds |
| Software version | pandas-profiling v3.6.6 |
| Download configuration | config.json |
No
Real number (ℝ)
| Distinct | 3313 |
|---|---|
| Distinct (%) | 45.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1663.8337 |
| Minimum | 3 |
|---|---|
| Maximum | 3345 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 57.1 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 148 |
| Q1 | 815.5 |
| median | 1679 |
| Q3 | 2507.5 |
| 95-th percentile | 3183.3 |
| Maximum | 3345 |
| Range | 3342 |
| Interquartile range (IQR) | 1692 |
Descriptive statistics
| Standard deviation | 974.33919 |
|---|---|
| Coefficient of variation (CV) | 0.5855989 |
| Kurtosis | -1.1980502 |
| Mean | 1663.8337 |
| Median Absolute Deviation (MAD) | 846 |
| Skewness | -0.00077986273 |
| Sum | 12137667 |
| Variance | 949336.86 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3174 | 13 | 0.2% |
| 3225 | 13 | 0.2% |
| 184 | 9 | 0.1% |
| 114 | 9 | 0.1% |
| 2142 | 9 | 0.1% |
| 440 | 8 | 0.1% |
| 16 | 8 | 0.1% |
| 778 | 7 | 0.1% |
| 3083 | 7 | 0.1% |
| 3304 | 7 | 0.1% |
| Other values (3303) | 7205 |
| Value | Count | Frequency (%) |
| 3 | 2 | |
| 4 | 2 | |
| 5 | 2 | |
| 6 | 4 | |
| 7 | 3 | |
| 8 | 3 | |
| 9 | 1 | < 0.1% |
| 10 | 2 | |
| 11 | 3 | |
| 12 | 3 |
| Value | Count | Frequency (%) |
| 3345 | 1 | < 0.1% |
| 3344 | 1 | < 0.1% |
| 3343 | 2 | |
| 3342 | 2 | |
| 3341 | 2 | |
| 3340 | 1 | < 0.1% |
| 3339 | 1 | < 0.1% |
| 3338 | 3 | |
| 3337 | 1 | < 0.1% |
| 3336 | 2 |
Date
Date
| Distinct | 373 |
|---|---|
| Distinct (%) | 5.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 57.1 KiB |
| Minimum | 2021-09-10 00:00:00 |
|---|---|
| Maximum | 2022-12-03 00:00:00 |
Histogram with fixed size bins (bins=50)
C/code
Real number (ℝ)
| Distinct | 221 |
|---|---|
| Distinct (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5187.6692 |
| Minimum | 2005 |
|---|---|
| Maximum | 9965 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 57.1 KiB |
Quantile statistics
| Minimum | 2005 |
|---|---|
| 5-th percentile | 2023 |
| Q1 | 2136 |
| median | 3403 |
| Q3 | 9024 |
| 95-th percentile | 9921 |
| Maximum | 9965 |
| Range | 7960 |
| Interquartile range (IQR) | 6888 |
Descriptive statistics
| Standard deviation | 3349.1661 |
|---|---|
| Coefficient of variation (CV) | 0.64560132 |
| Kurtosis | -1.7649357 |
| Mean | 5187.6692 |
| Median Absolute Deviation (MAD) | 1380 |
| Skewness | 0.33722082 |
| Sum | 37844047 |
| Variance | 11216913 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 8992 | 474 | 6.5% |
| 2159 | 254 | 3.5% |
| 9024 | 192 | 2.6% |
| 2023 | 177 | 2.4% |
| 2118 | 155 | 2.1% |
| 2069 | 149 | 2.0% |
| 6511 | 140 | 1.9% |
| 6544 | 131 | 1.8% |
| 2274 | 125 | 1.7% |
| 9451 | 124 | 1.7% |
| Other values (211) | 5374 |
| Value | Count | Frequency (%) |
| 2005 | 19 | 0.3% |
| 2007 | 71 | |
| 2009 | 75 | |
| 2011 | 10 | 0.1% |
| 2013 | 4 | 0.1% |
| 2014 | 52 | 0.7% |
| 2015 | 25 | 0.3% |
| 2019 | 71 | |
| 2022 | 3 | < 0.1% |
| 2023 | 177 |
| Value | Count | Frequency (%) |
| 9965 | 66 | |
| 9964 | 16 | 0.2% |
| 9953 | 44 | |
| 9952 | 26 | 0.4% |
| 9947 | 100 | |
| 9935 | 1 | < 0.1% |
| 9931 | 5 | 0.1% |
| 9929 | 46 | |
| 9927 | 55 | |
| 9921 | 22 | 0.3% |
Customer_name
Categorical
| Distinct | 214 |
|---|---|
| Distinct (%) | 2.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 57.1 KiB |
| PIZZA FLAME | 474 |
|---|---|
| SNACK FOOD CAFE | 254 |
| AL MAIDA 2 | 192 |
| ARYANA S/S | 177 |
| TOP TOWN | 155 |
| Other values (209) |
Length
| Max length | 30 |
|---|---|
| Median length | 22 |
| Mean length | 13.428239 |
| Min length | 4 |
Characters and Unicode
| Total characters | 97959 |
|---|---|
| Distinct characters | 53 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 17 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | BIG BITE FAST FOOD |
|---|---|
| 2nd row | BIG BITE FAST FOOD |
| 3rd row | PIZZA FLAME |
| 4th row | PIZZA FLAME |
| 5th row | CHIL & GRILL 0312.9553655 |
Common Values
| Value | Count | Frequency (%) |
| PIZZA FLAME | 474 | 6.5% |
| SNACK FOOD CAFE | 254 | 3.5% |
| AL MAIDA 2 | 192 | 2.6% |
| ARYANA S/S | 177 | 2.4% |
| TOP TOWN | 155 | 2.1% |
| CHIEF BURGER | 149 | 2.0% |
| USMAN GENERAL STORE | 140 | 1.9% |
| FOOD DISTRICT | 133 | 1.8% |
| CHATRAL | 131 | 1.8% |
| KHAWAJA GENERAL STORE | 125 | 1.7% |
| Other values (204) | 5365 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| store | 1715 | 9.7% |
| g/s | 1031 | 5.8% |
| general | 776 | 4.4% |
| super | 702 | 4.0% |
| food | 538 | 3.0% |
| pizza | 476 | 2.7% |
| flame | 474 | 2.7% |
| mart | 432 | 2.4% |
| bakers | 383 | 2.2% |
| al | 352 | 2.0% |
| Other values (269) | 10861 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 11776 | 12.0% |
| 10538 | 10.8% | |
| E | 7835 | 8.0% |
| S | 7794 | 8.0% |
| R | 7623 | 7.8% |
| O | 4752 | 4.9% |
| T | 4650 | 4.7% |
| I | 4442 | 4.5% |
| N | 3936 | 4.0% |
| L | 3646 | 3.7% |
| Other values (43) | 30967 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 81715 | |
| Space Separator | 10538 | 10.8% |
| Decimal Number | 3477 | 3.5% |
| Other Punctuation | 2037 | 2.1% |
| Lowercase Letter | 168 | 0.2% |
| Open Punctuation | 12 | < 0.1% |
| Close Punctuation | 12 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 11776 | |
| E | 7835 | 9.6% |
| S | 7794 | 9.5% |
| R | 7623 | 9.3% |
| O | 4752 | 5.8% |
| T | 4650 | 5.7% |
| I | 4442 | 5.4% |
| N | 3936 | 4.8% |
| L | 3646 | 4.5% |
| M | 2790 | 3.4% |
| Other values (16) | 22471 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 667 | |
| 3 | 621 | |
| 5 | 608 | |
| 9 | 430 | |
| 0 | 328 | |
| 1 | 275 | |
| 6 | 234 | 6.7% |
| 4 | 158 | 4.5% |
| 7 | 133 | 3.8% |
| 8 | 23 | 0.7% |
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 36 | |
| r | 24 | |
| e | 24 | |
| m | 12 | 7.1% |
| a | 12 | 7.1% |
| k | 12 | 7.1% |
| y | 12 | 7.1% |
| v | 12 | 7.1% |
| d | 12 | 7.1% |
| p | 12 | 7.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 1348 | |
| & | 316 | 15.5% |
| . | 210 | 10.3% |
| ' | 163 | 8.0% |
Space Separator
| Value | Count | Frequency (%) |
| 10538 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 12 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 12 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 81883 | |
| Common | 16076 | 16.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 11776 | |
| E | 7835 | 9.6% |
| S | 7794 | 9.5% |
| R | 7623 | 9.3% |
| O | 4752 | 5.8% |
| T | 4650 | 5.7% |
| I | 4442 | 5.4% |
| N | 3936 | 4.8% |
| L | 3646 | 4.5% |
| M | 2790 | 3.4% |
| Other values (26) | 22639 |
Common
| Value | Count | Frequency (%) |
| 10538 | ||
| / | 1348 | 8.4% |
| 2 | 667 | 4.1% |
| 3 | 621 | 3.9% |
| 5 | 608 | 3.8% |
| 9 | 430 | 2.7% |
| 0 | 328 | 2.0% |
| & | 316 | 2.0% |
| 1 | 275 | 1.7% |
| 6 | 234 | 1.5% |
| Other values (7) | 711 | 4.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 97959 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 11776 | 12.0% |
| 10538 | 10.8% | |
| E | 7835 | 8.0% |
| S | 7794 | 8.0% |
| R | 7623 | 7.8% |
| O | 4752 | 4.9% |
| T | 4650 | 4.7% |
| I | 4442 | 4.5% |
| N | 3936 | 4.0% |
| L | 3646 | 3.7% |
| Other values (43) | 30967 |
Customer_address
Categorical
| Distinct | 131 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 57.1 KiB |
| IBRAHIM MARKET | 498 |
|---|---|
| ZANGAL MARKET | 298 |
| FAQERA ABAD | 274 |
| OLD BARA ROAD | 251 |
| SADAR | 251 |
| Other values (126) |
Length
| Max length | 27 |
|---|---|
| Median length | 22 |
| Mean length | 12.910761 |
| Min length | 3 |
Characters and Unicode
| Total characters | 94184 |
|---|---|
| Distinct characters | 56 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | WARSAK ROAD |
|---|---|
| 2nd row | WARSAK ROAD |
| 3rd row | IBRAHIM MARKET |
| 4th row | IBRAHIM MARKET |
| 5th row | MOHMAD ZAI |
Common Values
| Value | Count | Frequency (%) |
| IBRAHIM MARKET | 498 | 6.8% |
| ZANGAL MARKET | 298 | 4.1% |
| FAQERA ABAD | 274 | 3.8% |
| OLD BARA ROAD | 251 | 3.4% |
| SADAR | 251 | 3.4% |
| University Town | 201 | 2.8% |
| PHASE 4 | 195 | 2.7% |
| CAMPUS | 185 | 2.5% |
| Nawab Market | 177 | 2.4% |
| UNIVERSITY ROAD | 172 | 2.4% |
| Other values (121) | 4793 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| market | 3143 | 20.1% |
| road | 1075 | 6.9% |
| university | 508 | 3.3% |
| ibrahim | 498 | 3.2% |
| town | 369 | 2.4% |
| nawab | 342 | 2.2% |
| bara | 303 | 1.9% |
| zangal | 298 | 1.9% |
| zai | 294 | 1.9% |
| abad | 287 | 1.8% |
| Other values (141) | 8490 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 14880 | |
| 8357 | 8.9% | |
| R | 8222 | 8.7% |
| E | 5170 | 5.5% |
| M | 4657 | 4.9% |
| T | 4540 | 4.8% |
| I | 3958 | 4.2% |
| D | 3282 | 3.5% |
| K | 3204 | 3.4% |
| B | 3142 | 3.3% |
| Other values (46) | 34772 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 73669 | |
| Lowercase Letter | 11585 | 12.3% |
| Space Separator | 8357 | 8.9% |
| Decimal Number | 542 | 0.6% |
| Other Punctuation | 31 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 14880 | |
| R | 8222 | |
| E | 5170 | 7.0% |
| M | 4657 | 6.3% |
| T | 4540 | 6.2% |
| I | 3958 | 5.4% |
| D | 3282 | 4.5% |
| K | 3204 | 4.3% |
| B | 3142 | 4.3% |
| S | 2978 | 4.0% |
| Other values (15) | 19636 |
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 2302 | |
| e | 1214 | |
| r | 1133 | |
| t | 1019 | |
| k | 825 | 7.1% |
| i | 675 | 5.8% |
| s | 672 | 5.8% |
| n | 655 | 5.7% |
| o | 564 | 4.9% |
| w | 483 | 4.2% |
| Other values (12) | 2043 |
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 197 | |
| 2 | 189 | |
| 6 | 137 | |
| 3 | 8 | 1.5% |
| 5 | 8 | 1.5% |
| 7 | 3 | 0.6% |
Other Punctuation
| Value | Count | Frequency (%) |
| ; | 29 | |
| , | 2 | 6.5% |
Space Separator
| Value | Count | Frequency (%) |
| 8357 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 85254 | |
| Common | 8930 | 9.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 14880 | |
| R | 8222 | 9.6% |
| E | 5170 | 6.1% |
| M | 4657 | 5.5% |
| T | 4540 | 5.3% |
| I | 3958 | 4.6% |
| D | 3282 | 3.8% |
| K | 3204 | 3.8% |
| B | 3142 | 3.7% |
| S | 2978 | 3.5% |
| Other values (37) | 31221 |
Common
| Value | Count | Frequency (%) |
| 8357 | ||
| 4 | 197 | 2.2% |
| 2 | 189 | 2.1% |
| 6 | 137 | 1.5% |
| ; | 29 | 0.3% |
| 3 | 8 | 0.1% |
| 5 | 8 | 0.1% |
| 7 | 3 | < 0.1% |
| , | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 94184 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 14880 | |
| 8357 | 8.9% | |
| R | 8222 | 8.7% |
| E | 5170 | 5.5% |
| M | 4657 | 4.9% |
| T | 4540 | 4.8% |
| I | 3958 | 4.2% |
| D | 3282 | 3.5% |
| K | 3204 | 3.4% |
| B | 3142 | 3.3% |
| Other values (46) | 34772 |
Item_code
Real number (ℝ)
| Distinct | 14 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1764.2591 |
| Minimum | 1758 |
|---|---|
| Maximum | 1788 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 57.1 KiB |
Quantile statistics
| Minimum | 1758 |
|---|---|
| 5-th percentile | 1758 |
| Q1 | 1760 |
| median | 1763 |
| Q3 | 1770 |
| 95-th percentile | 1772 |
| Maximum | 1788 |
| Range | 30 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 5.414342 |
|---|---|
| Coefficient of variation (CV) | 0.0030689042 |
| Kurtosis | 0.32474347 |
| Mean | 1764.2591 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 0.80514149 |
| Sum | 12870270 |
| Variance | 29.3151 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=14)
| Value | Count | Frequency (%) |
| 1760 | 1392 | |
| 1763 | 1253 | |
| 1758 | 1173 | |
| 1770 | 1150 | |
| 1771 | 997 | |
| 1762 | 854 | |
| 1772 | 288 | 3.9% |
| 1761 | 59 | 0.8% |
| 1784 | 59 | 0.8% |
| 1759 | 47 | 0.6% |
| Other values (4) | 23 | 0.3% |
| Value | Count | Frequency (%) |
| 1758 | 1173 | |
| 1759 | 47 | 0.6% |
| 1760 | 1392 | |
| 1761 | 59 | 0.8% |
| 1762 | 854 | |
| 1763 | 1253 | |
| 1770 | 1150 | |
| 1771 | 997 | |
| 1772 | 288 | 3.9% |
| 1784 | 59 | 0.8% |
| Value | Count | Frequency (%) |
| 1788 | 3 | < 0.1% |
| 1787 | 2 | < 0.1% |
| 1786 | 10 | 0.1% |
| 1785 | 8 | 0.1% |
| 1784 | 59 | 0.8% |
| 1772 | 288 | 3.9% |
| 1771 | 997 | |
| 1770 | 1150 | |
| 1763 | 1253 | |
| 1762 | 854 |
Product_name
Categorical
| Distinct | 16 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 57.1 KiB |
| DEEN'S MOZARELLA 200GM | |
|---|---|
| DEEN'S SLICE CHEESE 200GM | |
| DEEN'S CHEDDAR 200GM | |
| DEEN'S CHADDER CHEESE BLOCK 2K | |
| DEEN'S MOZRELLA CHEESE BLOCK | |
| Other values (11) |
Length
| Max length | 30 |
|---|---|
| Median length | 28 |
| Mean length | 24.57889 |
| Min length | 16 |
Characters and Unicode
| Total characters | 179303 |
|---|---|
| Distinct characters | 30 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | DEEN'S CHADDER CHEESE BLOCK 2K |
|---|---|
| 2nd row | DEEN'S MOZRELLA CHEESE BLOCK |
| 3rd row | DEEN'S CHADDER CHEESE BLOCK 2K |
| 4th row | DEEN'S MOZRELLA CHEESE BLOCK |
| 5th row | DEEN'S CHADDER CHEESE BLOCK 2K |
Common Values
| Value | Count | Frequency (%) |
| DEEN'S MOZARELLA 200GM | 1392 | |
| DEEN'S SLICE CHEESE 200GM | 1253 | |
| DEEN'S CHEDDAR 200GM | 1173 | |
| DEEN'S CHADDER CHEESE BLOCK 2K | 1150 | |
| DEEN'S MOZRELLA CHEESE BLOCK | 997 | |
| DEEN'S PIZZA CHEESE 200GM | 854 | |
| DEEN SLICE CHEESE 1 KG | 192 | 2.6% |
| DEEN'S SLICE CHEESE 1 KG | 95 | 1.3% |
| DEEN'S MOZARELLA 400GM | 59 | 0.8% |
| DEENS SLICE 250G | 59 | 0.8% |
| Other values (6) | 71 | 1.0% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| deen's | 7020 | |
| 200gm | 4672 | |
| cheese | 4542 | |
| block | 2147 | 7.7% |
| slice | 1600 | 5.7% |
| mozarella | 1451 | 5.2% |
| cheddar | 1220 | 4.4% |
| chadder | 1160 | 4.2% |
| 2k | 1150 | 4.1% |
| mozrella | 1007 | 3.6% |
| Other values (11) | 1896 | 6.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 34652 | |
| 20570 | ||
| S | 13244 | 7.4% |
| D | 12055 | 6.7% |
| C | 10669 | 6.0% |
| 0 | 9641 | 5.4% |
| L | 8663 | 4.8% |
| N | 7294 | 4.1% |
| M | 7236 | 4.0% |
| A | 7146 | 4.0% |
| Other values (20) | 48133 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 135690 | |
| Space Separator | 20570 | 11.5% |
| Decimal Number | 16019 | 8.9% |
| Other Punctuation | 7020 | 3.9% |
| Lowercase Letter | 3 | < 0.1% |
| Dash Punctuation | 1 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 34652 | |
| S | 13244 | 9.8% |
| D | 12055 | 8.9% |
| C | 10669 | 7.9% |
| L | 8663 | 6.4% |
| N | 7294 | 5.4% |
| M | 7236 | 5.3% |
| A | 7146 | 5.3% |
| H | 6922 | 5.1% |
| G | 5148 | 3.8% |
| Other values (7) | 22661 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 9641 | |
| 2 | 5881 | |
| 1 | 306 | 1.9% |
| 4 | 128 | 0.8% |
| 5 | 59 | 0.4% |
| 9 | 2 | < 0.1% |
| 7 | 2 | < 0.1% |
Lowercase Letter
| Value | Count | Frequency (%) |
| w | 1 | |
| y | 1 | |
| h | 1 |
Space Separator
| Value | Count | Frequency (%) |
| 20570 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 7020 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 135693 | |
| Common | 43610 | 24.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 34652 | |
| S | 13244 | 9.8% |
| D | 12055 | 8.9% |
| C | 10669 | 7.9% |
| L | 8663 | 6.4% |
| N | 7294 | 5.4% |
| M | 7236 | 5.3% |
| A | 7146 | 5.3% |
| H | 6922 | 5.1% |
| G | 5148 | 3.8% |
| Other values (10) | 22664 |
Common
| Value | Count | Frequency (%) |
| 20570 | ||
| 0 | 9641 | |
| ' | 7020 | 16.1% |
| 2 | 5881 | 13.5% |
| 1 | 306 | 0.7% |
| 4 | 128 | 0.3% |
| 5 | 59 | 0.1% |
| 9 | 2 | < 0.1% |
| 7 | 2 | < 0.1% |
| - | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 179303 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 34652 | |
| 20570 | ||
| S | 13244 | 7.4% |
| D | 12055 | 6.7% |
| C | 10669 | 6.0% |
| 0 | 9641 | 5.4% |
| L | 8663 | 4.8% |
| N | 7294 | 4.1% |
| M | 7236 | 4.0% |
| A | 7146 | 4.0% |
| Other values (20) | 48133 |
Orignal_price
Real number (ℝ)
| Distinct | 43 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23850.73 |
| Minimum | 14400 |
|---|---|
| Maximum | 36006 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 57.1 KiB |
Quantile statistics
| Minimum | 14400 |
|---|---|
| 5-th percentile | 15840 |
| Q1 | 21180 |
| median | 23725 |
| Q3 | 26650 |
| 95-th percentile | 31460 |
| Maximum | 36006 |
| Range | 21606 |
| Interquartile range (IQR) | 5470 |
Descriptive statistics
| Standard deviation | 4820.6164 |
|---|---|
| Coefficient of variation (CV) | 0.20211609 |
| Kurtosis | -0.59108625 |
| Mean | 23850.73 |
| Median Absolute Deviation (MAD) | 2925 |
| Skewness | -0.21520351 |
| Sum | 1.7399107 × 108 |
| Variance | 23238342 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=43)
| Value | Count | Frequency (%) |
| 15900 | 549 | 7.5% |
| 21180 | 488 | 6.7% |
| 29315 | 381 | 5.2% |
| 30880 | 379 | 5.2% |
| 22425 | 356 | 4.9% |
| 23600 | 350 | 4.8% |
| 26650 | 335 | 4.6% |
| 22550 | 313 | 4.3% |
| 26390 | 312 | 4.3% |
| 20150 | 305 | 4.2% |
| Other values (33) | 3527 |
| Value | Count | Frequency (%) |
| 14400 | 86 | 1.2% |
| 14500 | 236 | |
| 15840 | 133 | 1.8% |
| 15900 | 549 | |
| 16900 | 52 | 0.7% |
| 17600 | 69 | 0.9% |
| 19250 | 211 | 2.9% |
| 20150 | 305 | |
| 20700 | 21 | 0.3% |
| 21180 | 488 |
| Value | Count | Frequency (%) |
| 36006 | 10 | 0.1% |
| 34848 | 56 | 0.8% |
| 33660 | 3 | < 0.1% |
| 32472 | 80 | 1.1% |
| 31460 | 217 | |
| 31314 | 8 | 0.1% |
| 30880 | 379 | |
| 30600 | 13 | 0.2% |
| 29315 | 381 | |
| 29232 | 65 | 0.9% |
CTN
Real number (ℝ)
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.14201508 |
| Minimum | 0 |
|---|---|
| Maximum | 12 |
| Zeros | 6983 |
| Zeros (%) | 95.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 57.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 12 |
| Range | 12 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.87440468 |
|---|---|
| Coefficient of variation (CV) | 6.1571256 |
| Kurtosis | 70.343437 |
| Mean | 0.14201508 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.9089773 |
| Sum | 1036 |
| Variance | 0.76458355 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=11)
| Value | Count | Frequency (%) |
| 0 | 6983 | |
| 1 | 126 | 1.7% |
| 5 | 43 | 0.6% |
| 2 | 41 | 0.6% |
| 4 | 27 | 0.4% |
| 10 | 20 | 0.3% |
| 3 | 19 | 0.3% |
| 6 | 16 | 0.2% |
| 7 | 12 | 0.2% |
| 8 | 7 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 6983 | |
| 1 | 126 | 1.7% |
| 2 | 41 | 0.6% |
| 3 | 19 | 0.3% |
| 4 | 27 | 0.4% |
| 5 | 43 | 0.6% |
| 6 | 16 | 0.2% |
| 7 | 12 | 0.2% |
| 8 | 7 | 0.1% |
| 10 | 20 | 0.3% |
| Value | Count | Frequency (%) |
| 12 | 1 | < 0.1% |
| 10 | 20 | 0.3% |
| 8 | 7 | 0.1% |
| 7 | 12 | 0.2% |
| 6 | 16 | 0.2% |
| 5 | 43 | 0.6% |
| 4 | 27 | 0.4% |
| 3 | 19 | 0.3% |
| 2 | 41 | 0.6% |
| 1 | 126 |
PCS
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 36 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.0138451 |
| Minimum | 1 |
|---|---|
| Maximum | 714 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 57.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 12 |
| Maximum | 714 |
| Range | 713 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 15.520357 |
|---|---|
| Coefficient of variation (CV) | 3.0955 |
| Kurtosis | 1202.9283 |
| Mean | 5.0138451 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 28.053501 |
| Sum | 36576 |
| Variance | 240.88149 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=36)
| Value | Count | Frequency (%) |
| 2 | 2212 | |
| 3 | 1679 | |
| 1 | 1185 | |
| 6 | 800 | 11.0% |
| 4 | 700 | 9.6% |
| 10 | 128 | 1.8% |
| 5 | 128 | 1.8% |
| 12 | 93 | 1.3% |
| 8 | 79 | 1.1% |
| 50 | 45 | 0.6% |
| Other values (26) | 246 | 3.4% |
| Value | Count | Frequency (%) |
| 1 | 1185 | |
| 2 | 2212 | |
| 3 | 1679 | |
| 4 | 700 | 9.6% |
| 5 | 128 | 1.8% |
| 6 | 800 | 11.0% |
| 7 | 8 | 0.1% |
| 8 | 79 | 1.1% |
| 9 | 1 | < 0.1% |
| 10 | 128 | 1.8% |
| Value | Count | Frequency (%) |
| 714 | 2 | < 0.1% |
| 160 | 1 | < 0.1% |
| 144 | 2 | < 0.1% |
| 120 | 1 | < 0.1% |
| 102 | 2 | < 0.1% |
| 100 | 20 | |
| 80 | 11 | |
| 72 | 12 | |
| 70 | 12 | |
| 66 | 2 | < 0.1% |
Total_discount
Real number (ℝ)
HIGH CORRELATION SKEWED ZEROS
| Distinct | 341 |
|---|---|
| Distinct (%) | 4.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 199.38944 |
| Minimum | -120 |
|---|---|
| Maximum | 53125 |
| Zeros | 4855 |
| Zeros (%) | 66.6% |
| Negative | 2 |
| Negative (%) | < 0.1% |
| Memory size | 57.1 KiB |
Quantile statistics
| Minimum | -120 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 90 |
| 95-th percentile | 480 |
| Maximum | 53125 |
| Range | 53245 |
| Interquartile range (IQR) | 90 |
Descriptive statistics
| Standard deviation | 1275.6995 |
|---|---|
| Coefficient of variation (CV) | 6.3980292 |
| Kurtosis | 850.37653 |
| Mean | 199.38944 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 23.545443 |
| Sum | 1454546 |
| Variance | 1627409.2 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 4855 | |
| 180 | 175 | 2.4% |
| 200 | 134 | 1.8% |
| 90 | 115 | 1.6% |
| 150 | 108 | 1.5% |
| 270 | 93 | 1.3% |
| 236 | 88 | 1.2% |
| 30 | 69 | 0.9% |
| 88 | 69 | 0.9% |
| 354 | 62 | 0.8% |
| Other values (331) | 1527 | 20.9% |
| Value | Count | Frequency (%) |
| -120 | 1 | < 0.1% |
| -50 | 1 | < 0.1% |
| 0 | 4855 | |
| 7 | 2 | < 0.1% |
| 8 | 3 | < 0.1% |
| 9 | 2 | < 0.1% |
| 11 | 1 | < 0.1% |
| 14 | 2 | < 0.1% |
| 15 | 2 | < 0.1% |
| 16 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 53125 | 2 | |
| 24220 | 1 | < 0.1% |
| 14000 | 2 | |
| 13080 | 1 | < 0.1% |
| 12000 | 3 | |
| 11800 | 2 | |
| 11600 | 1 | < 0.1% |
| 11400 | 1 | < 0.1% |
| 11124 | 1 | < 0.1% |
| 10900 | 2 |
Discount_price
Real number (ℝ)
| Distinct | 741 |
|---|---|
| Distinct (%) | 10.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4995.5707 |
| Minimum | -26735 |
|---|---|
| Maximum | 258600 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 2 |
| Negative (%) | < 0.1% |
| Memory size | 57.1 KiB |
Quantile statistics
| Minimum | -26735 |
|---|---|
| 5-th percentile | 406 |
| Q1 | 902 |
| median | 1500 |
| Q3 | 2904 |
| 95-th percentile | 11600 |
| Maximum | 258600 |
| Range | 285335 |
| Interquartile range (IQR) | 2002 |
Descriptive statistics
| Standard deviation | 17722.557 |
|---|---|
| Coefficient of variation (CV) | 3.547654 |
| Kurtosis | 74.995887 |
| Mean | 4995.5707 |
| Median Absolute Deviation (MAD) | 770 |
| Skewness | 8.0410524 |
| Sum | 36442689 |
| Variance | 3.1408901 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3000 | 148 | 2.0% |
| 2700 | 147 | 2.0% |
| 812 | 126 | 1.7% |
| 1353 | 125 | 1.7% |
| 902 | 121 | 1.7% |
| 3700 | 111 | 1.5% |
| 2255 | 110 | 1.5% |
| 690 | 105 | 1.4% |
| 1158 | 101 | 1.4% |
| 1218 | 93 | 1.3% |
| Other values (731) | 6108 |
| Value | Count | Frequency (%) |
| -26735 | 1 | |
| -21811 | 1 | |
| 2 | 1 | |
| 224 | 1 | |
| 247 | 1 | |
| 264 | 1 | |
| 278 | 1 | |
| 281 | 2 | |
| 282 | 1 | |
| 287 | 1 |
| Value | Count | Frequency (%) |
| 258600 | 1 | < 0.1% |
| 225500 | 7 | |
| 215500 | 5 | |
| 201280 | 1 | < 0.1% |
| 200000 | 2 | < 0.1% |
| 180400 | 4 | |
| 172400 | 1 | < 0.1% |
| 160000 | 1 | < 0.1% |
| 157850 | 5 | |
| 153600 | 2 | < 0.1% |
Discount_per_piece
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 262 |
|---|---|
| Distinct (%) | 3.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.963851 |
| Minimum | -60 |
|---|---|
| Maximum | 901 |
| Zeros | 4855 |
| Zeros (%) | 66.6% |
| Negative | 2 |
| Negative (%) | < 0.1% |
| Memory size | 57.1 KiB |
Quantile statistics
| Minimum | -60 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 24.166667 |
| 95-th percentile | 118 |
| Maximum | 901 |
| Range | 961 |
| Interquartile range (IQR) | 24.166667 |
Descriptive statistics
| Standard deviation | 53.777863 |
|---|---|
| Coefficient of variation (CV) | 1.994443 |
| Kurtosis | 31.924342 |
| Mean | 26.963851 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.803901 |
| Sum | 196701.29 |
| Variance | 2892.0586 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 4855 | |
| 90 | 430 | 5.9% |
| 100 | 244 | 3.3% |
| 118 | 238 | 3.3% |
| 75 | 179 | 2.5% |
| 88 | 151 | 2.1% |
| 30 | 128 | 1.8% |
| 140 | 72 | 1.0% |
| 218 | 53 | 0.7% |
| 17 | 38 | 0.5% |
| Other values (252) | 907 | 12.4% |
| Value | Count | Frequency (%) |
| -60 | 1 | < 0.1% |
| -50 | 1 | < 0.1% |
| 0 | 4855 | |
| 4 | 1 | < 0.1% |
| 7 | 2 | < 0.1% |
| 7.5 | 1 | < 0.1% |
| 8 | 3 | < 0.1% |
| 8.333333333 | 1 | < 0.1% |
| 8.5 | 2 | < 0.1% |
| 8.666666667 | 4 | 0.1% |
| Value | Count | Frequency (%) |
| 901 | 1 | |
| 822 | 1 | |
| 817.3076923 | 1 | |
| 620.5 | 1 | |
| 564.6 | 1 | |
| 556.2 | 1 | |
| 520.8333333 | 1 | |
| 426.5 | 1 | |
| 409 | 1 | |
| 358 | 2 |
Month
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.9039068 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 57.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 7 |
| Q3 | 10 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.543332 |
|---|---|
| Coefficient of variation (CV) | 0.51323578 |
| Kurtosis | -1.3850468 |
| Mean | 6.9039068 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.1723748 |
| Sum | 50364 |
| Variance | 12.555201 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 11 | 994 | |
| 10 | 869 | |
| 9 | 824 | |
| 4 | 756 | |
| 3 | 660 | |
| 2 | 581 | |
| 12 | 524 | |
| 1 | 476 | |
| 6 | 431 | |
| 5 | 420 | |
| Other values (2) | 760 |
| Value | Count | Frequency (%) |
| 1 | 476 | |
| 2 | 581 | |
| 3 | 660 | |
| 4 | 756 | |
| 5 | 420 | |
| 6 | 431 | |
| 7 | 372 | |
| 8 | 388 | |
| 9 | 824 | |
| 10 | 869 |
| Value | Count | Frequency (%) |
| 12 | 524 | |
| 11 | 994 | |
| 10 | 869 | |
| 9 | 824 | |
| 8 | 388 | 5.3% |
| 7 | 372 | 5.1% |
| 6 | 431 | |
| 5 | 420 | |
| 4 | 756 | |
| 3 | 660 |
Price Range
Categorical
HIGH CORRELATION MISSING
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 766 |
| Missing (%) | 10.5% |
| Memory size | 7.4 KiB |
| High Price | |
|---|---|
| Medium Price |
Length
| Max length | 12 |
|---|---|
| Median length | 10 |
| Mean length | 10.409251 |
| Min length | 10 |
Characters and Unicode
| Total characters | 67962 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Medium Price |
|---|---|
| 2nd row | Medium Price |
| 3rd row | Medium Price |
| 4th row | Medium Price |
| 5th row | Medium Price |
Common Values
| Value | Count | Frequency (%) |
| High Price | 5193 | |
| Medium Price | 1336 | 18.3% |
| (Missing) | 766 | 10.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| price | 6529 | |
| high | 5193 | |
| medium | 1336 | 10.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 13058 | |
| e | 7865 | |
| 6529 | ||
| P | 6529 | |
| r | 6529 | |
| c | 6529 | |
| H | 5193 | 7.6% |
| g | 5193 | 7.6% |
| h | 5193 | 7.6% |
| M | 1336 | 2.0% |
| Other values (3) | 4008 | 5.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 48375 | |
| Uppercase Letter | 13058 | 19.2% |
| Space Separator | 6529 | 9.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 13058 | |
| e | 7865 | |
| r | 6529 | |
| c | 6529 | |
| g | 5193 | 10.7% |
| h | 5193 | 10.7% |
| d | 1336 | 2.8% |
| u | 1336 | 2.8% |
| m | 1336 | 2.8% |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 6529 | |
| H | 5193 | |
| M | 1336 | 10.2% |
Space Separator
| Value | Count | Frequency (%) |
| 6529 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 61433 | |
| Common | 6529 | 9.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 13058 | |
| e | 7865 | |
| P | 6529 | |
| r | 6529 | |
| c | 6529 | |
| H | 5193 | 8.5% |
| g | 5193 | 8.5% |
| h | 5193 | 8.5% |
| M | 1336 | 2.2% |
| d | 1336 | 2.2% |
| Other values (2) | 2672 | 4.3% |
Common
| Value | Count | Frequency (%) |
| 6529 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 67962 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| i | 13058 | |
| e | 7865 | |
| 6529 | ||
| P | 6529 | |
| r | 6529 | |
| c | 6529 | |
| H | 5193 | 7.6% |
| g | 5193 | 7.6% |
| h | 5193 | 7.6% |
| M | 1336 | 2.0% |
| Other values (3) | 4008 | 5.9% |
Has_Discount
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 57.1 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 7295 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 4857 | |
| 1 | 2438 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 4857 | |
| 1 | 2438 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 4857 | |
| 1 | 2438 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 7295 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 4857 | |
| 1 | 2438 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 7295 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 4857 | |
| 1 | 2438 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7295 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 4857 | |
| 1 | 2438 |
| No | C/code | Item_code | Orignal_price | CTN | PCS | Total_discount | Discount_price | Discount_per_piece | Month | Product_name | Price Range | Has_Discount | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| No | 1.000 | -0.050 | 0.017 | 0.590 | 0.080 | 0.030 | -0.246 | 0.127 | -0.252 | -0.012 | 0.130 | 0.218 | 0.366 |
| C/code | -0.050 | 1.000 | 0.215 | -0.195 | -0.032 | -0.239 | 0.065 | 0.037 | 0.081 | 0.035 | 0.208 | 0.296 | 0.283 |
| Item_code | 0.017 | 0.215 | 1.000 | -0.379 | 0.195 | -0.129 | 0.452 | 0.525 | 0.484 | -0.044 | 0.999 | 0.705 | 0.555 |
| Orignal_price | 0.590 | -0.195 | -0.379 | 1.000 | -0.127 | 0.150 | -0.552 | -0.317 | -0.583 | 0.028 | 0.456 | 0.937 | 0.571 |
| CTN | 0.080 | -0.032 | 0.195 | -0.127 | 1.000 | 0.353 | 0.250 | 0.348 | 0.195 | -0.000 | 0.083 | 0.036 | 0.145 |
| PCS | 0.030 | -0.239 | -0.129 | 0.150 | 0.353 | 1.000 | 0.131 | 0.542 | 0.035 | -0.001 | 0.271 | 0.000 | 0.051 |
| Total_discount | -0.246 | 0.065 | 0.452 | -0.552 | 0.250 | 0.131 | 1.000 | 0.555 | 0.984 | -0.171 | 0.141 | 0.051 | 0.135 |
| Discount_price | 0.127 | 0.037 | 0.525 | -0.317 | 0.348 | 0.542 | 0.555 | 1.000 | 0.519 | -0.079 | 0.232 | 0.328 | 0.461 |
| Discount_per_piece | -0.252 | 0.081 | 0.484 | -0.583 | 0.195 | 0.035 | 0.984 | 0.519 | 1.000 | -0.184 | 0.283 | 0.595 | 0.757 |
| Month | -0.012 | 0.035 | -0.044 | 0.028 | -0.000 | -0.001 | -0.171 | -0.079 | -0.184 | 1.000 | 0.091 | 0.137 | 0.270 |
| Product_name | 0.130 | 0.208 | 0.999 | 0.456 | 0.083 | 0.271 | 0.141 | 0.232 | 0.283 | 0.091 | 1.000 | 0.792 | 0.563 |
| Price Range | 0.218 | 0.296 | 0.705 | 0.937 | 0.036 | 0.000 | 0.051 | 0.328 | 0.595 | 0.137 | 0.792 | 1.000 | 0.515 |
| Has_Discount | 0.366 | 0.283 | 0.555 | 0.571 | 0.145 | 0.051 | 0.135 | 0.461 | 0.757 | 0.270 | 0.563 | 0.515 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| No | Date | C/code | Customer_name | Customer_address | Item_code | Product_name | Orignal_price | CTN | PCS | Total_discount | Discount_price | Discount_per_piece | Month | Price Range | Has_Discount | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 3 | 2021-09-10 | 9295 | BIG BITE FAST FOOD | WARSAK ROAD | 1770 | DEEN'S CHADDER CHEESE BLOCK 2K | 14500 | 1 | 10 | 1000 | 13500.0 | 100.0 | 9 | Medium Price | 1 |
| 1 | 3 | 2021-09-10 | 9295 | BIG BITE FAST FOOD | WARSAK ROAD | 1771 | DEEN'S MOZRELLA CHEESE BLOCK | 19250 | 0 | 5 | 375 | 9250.0 | 75.0 | 9 | Medium Price | 1 |
| 2 | 4 | 2021-09-10 | 8992 | PIZZA FLAME | IBRAHIM MARKET | 1770 | DEEN'S CHADDER CHEESE BLOCK 2K | 14500 | 0 | 2 | 200 | 2700.0 | 100.0 | 9 | Medium Price | 1 |
| 3 | 4 | 2021-09-10 | 8992 | PIZZA FLAME | IBRAHIM MARKET | 1771 | DEEN'S MOZRELLA CHEESE BLOCK | 19250 | 0 | 2 | 150 | 3700.0 | 75.0 | 9 | Medium Price | 1 |
| 4 | 5 | 2021-09-10 | 9903 | CHIL & GRILL 0312.9553655 | MOHMAD ZAI | 1770 | DEEN'S CHADDER CHEESE BLOCK 2K | 14500 | 0 | 2 | 200 | 2700.0 | 100.0 | 9 | Medium Price | 1 |
| 5 | 5 | 2021-09-10 | 9903 | CHIL & GRILL 0312.9553655 | MOHMAD ZAI | 1771 | DEEN'S MOZRELLA CHEESE BLOCK | 19250 | 0 | 2 | 150 | 3700.0 | 75.0 | 9 | Medium Price | 1 |
| 6 | 6 | 2021-09-11 | 6544 | CHATRAL | CAMPUS | 1758 | DEEN'S CHEDDAR 200GM | 20150 | 0 | 4 | 0 | 1240.0 | 0.0 | 9 | High Price | 0 |
| 7 | 6 | 2021-09-11 | 6544 | CHATRAL | CAMPUS | 1760 | DEEN'S MOZARELLA 200GM | 22425 | 0 | 6 | 0 | 2070.0 | 0.0 | 9 | High Price | 0 |
| 8 | 6 | 2021-09-11 | 6544 | CHATRAL | CAMPUS | 1762 | DEEN'S PIZZA CHEESE 200GM | 24050 | 0 | 2 | 0 | 740.0 | 0.0 | 9 | High Price | 0 |
| 9 | 6 | 2021-09-11 | 6544 | CHATRAL | CAMPUS | 1763 | DEEN'S SLICE CHEESE 200GM | 23600 | 0 | 2 | 0 | 590.0 | 0.0 | 9 | High Price | 0 |
| No | Date | C/code | Customer_name | Customer_address | Item_code | Product_name | Orignal_price | CTN | PCS | Total_discount | Discount_price | Discount_per_piece | Month | Price Range | Has_Discount | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7285 | 3339 | 2022-12-02 | 3483 | PICK IN SAVE | KHYBER SUPER MARKET | 1784 | DEENS SLICE 250G | 28116 | 0 | 6 | 0 | 2556.0 | 0.0 | 12 | High Price | 0 |
| 7286 | 3340 | 2022-12-02 | 2063 | QURESHI G/S | Saddar Cantt Peshawar | 1760 | DEEN'S MOZARELLA 200GM | 32472 | 0 | 12 | 270 | 5142.0 | 22.5 | 12 | NaN | 1 |
| 7287 | 3341 | 2022-12-02 | 8907 | INSAF FAST FOOD | BILAL MARKET | 1770 | DEEN'S CHADDER CHEESE BLOCK 2K | 22550 | 0 | 1 | 0 | 2255.0 | 0.0 | 12 | High Price | 0 |
| 7288 | 3341 | 2022-12-02 | 8907 | INSAF FAST FOOD | BILAL MARKET | 1771 | DEEN'S MOZRELLA CHEESE BLOCK | 25850 | 0 | 2 | 0 | 5170.0 | 0.0 | 12 | High Price | 0 |
| 7289 | 3342 | 2022-12-03 | 9947 | OTIMO | RISALPOOR | 1770 | DEEN'S CHADDER CHEESE BLOCK 2K | 22550 | 0 | 3 | 0 | 6765.0 | 0.0 | 12 | High Price | 0 |
| 7290 | 3342 | 2022-12-03 | 9947 | OTIMO | RISALPOOR | 1771 | DEEN'S MOZRELLA CHEESE BLOCK | 25850 | 0 | 3 | 0 | 7755.0 | 0.0 | 12 | High Price | 0 |
| 7291 | 3343 | 2022-12-03 | 3445 | FOOD DISTRICT | SADAR | 1771 | DEEN'S MOZRELLA CHEESE BLOCK | 25850 | 0 | 2 | 0 | 5170.0 | 0.0 | 12 | High Price | 0 |
| 7292 | 3343 | 2022-12-03 | 3445 | FOOD DISTRICT | SADAR | 1770 | DEEN'S CHADDER CHEESE BLOCK 2K | 22550 | 0 | 2 | 0 | 4510.0 | 0.0 | 12 | High Price | 0 |
| 7293 | 3344 | 2022-12-03 | 3467 | IQRA SWEET & BAKERS | CAMPUS | 1784 | DEENS SLICE 250G | 28116 | 0 | 2 | 0 | 852.0 | 0.0 | 12 | High Price | 0 |
| 7294 | 3345 | 2022-12-03 | 9031 | UNIVERSITY BAKERS 03335992712 | PESHAWAR UNIVERSITY | 1759 | DEEN'S CHEDDAR 400GM | 27072 | 0 | 3 | 0 | 2256.0 | 0.0 | 12 | High Price | 0 |
Most frequently occurring
| No | Date | C/code | Customer_name | Customer_address | Item_code | Product_name | Orignal_price | CTN | PCS | Total_discount | Discount_price | Discount_per_piece | Month | Price Range | Has_Discount | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 398 | 896 | 2022-01-03 | 2330 | NAWAZ GENERAL STORE | FAQERA ABAD | 1760 | DEEN'S MOZARELLA 200GM | 24635 | 0 | 2 | 0 | 758.0 | 0.0 | 1 | High Price | 0 | 2 |
| 5747 | 3306 | 2022-11-26 | 3445 | FOOD DISTRICT | SADAR | 1771 | DEEN'S MOZRELLA CHEESE BLOCK | 25850 | 0 | 1 | 0 | 2585.0 | 0.0 | 11 | High Price | 0 | 2 |
| 0 | 896 | 2022-01-03 | 2330 | FOOD DISTRICT | FAQERA ABAD | 1760 | DEEN'S MOZARELLA 200GM | 24635 | 0 | 1 | 0 | 758.0 | 0.0 | 1 | Low Price | 0 | 0 |
| 1 | 896 | 2022-01-03 | 2330 | FOOD DISTRICT | FAQERA ABAD | 1760 | DEEN'S MOZARELLA 200GM | 24635 | 0 | 1 | 0 | 758.0 | 0.0 | 1 | Medium Price | 0 | 0 |
| 2 | 896 | 2022-01-03 | 2330 | FOOD DISTRICT | FAQERA ABAD | 1760 | DEEN'S MOZARELLA 200GM | 24635 | 0 | 1 | 0 | 758.0 | 0.0 | 1 | High Price | 0 | 0 |
| 3 | 896 | 2022-01-03 | 2330 | FOOD DISTRICT | FAQERA ABAD | 1760 | DEEN'S MOZARELLA 200GM | 24635 | 0 | 1 | 0 | 758.0 | 0.0 | 11 | Low Price | 0 | 0 |
| 4 | 896 | 2022-01-03 | 2330 | FOOD DISTRICT | FAQERA ABAD | 1760 | DEEN'S MOZARELLA 200GM | 24635 | 0 | 1 | 0 | 758.0 | 0.0 | 11 | Medium Price | 0 | 0 |
| 5 | 896 | 2022-01-03 | 2330 | FOOD DISTRICT | FAQERA ABAD | 1760 | DEEN'S MOZARELLA 200GM | 24635 | 0 | 1 | 0 | 758.0 | 0.0 | 11 | High Price | 0 | 0 |
| 6 | 896 | 2022-01-03 | 2330 | FOOD DISTRICT | FAQERA ABAD | 1760 | DEEN'S MOZARELLA 200GM | 24635 | 0 | 1 | 0 | 2585.0 | 0.0 | 1 | Low Price | 0 | 0 |
| 7 | 896 | 2022-01-03 | 2330 | FOOD DISTRICT | FAQERA ABAD | 1760 | DEEN'S MOZARELLA 200GM | 24635 | 0 | 1 | 0 | 2585.0 | 0.0 | 1 | Medium Price | 0 | 0 |